package com.lab303.powerproject.repository;

import com.lab303.powerproject.entity.Remain;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface RemainRepository extends JpaRepository<Remain,Integer> {

    @Query(nativeQuery = true,value = "SELECT remain.* FROM remain WHERE DATE_FORMAT(remain.date,'%m-%d')=?1")
    Remain findRemainByDateTime(String MMdd);
}
